Sync Schema

The Sync Schema function refreshes the metadata and syncs the schema diagram with the latest changes to the underlying database.

Sync Entire Model

The sync schema function reads the underlying database for the entire model and fetches new columns, inserts them into the diagram and removes old columns from the diagram. If the name, column type, or length is changed, the changes will reflect on the diagram.

Note: The sync schema function is only enabled (only runs) if a direct query datasource is used for the model.

Sync Table Schema

The sync schema function can also be applied to a specific table by right clicking on the table and selecting Sync Table Schema.

The Sync Table Schema function reads the underlying database for the specified table only and fetches new columns, inserts them into the diagram and removes old columns from the diagram. If the name, column type, or length is changed, the changes will reflect on the diagram.